package com.jackrain.nea.fc.dl.mapper;


import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.HashMap;

/**
 * （入库回传）采购入库
 * Mapper
 *
 * @author xuxinshuai
 * @create 2018/05/12
 */
@Mapper
public interface WmsOrderInMapper {


    @Select("SELECT ID,BILL_TYPE FROM DL_B_PUR_ORDER WHERE BILL_NO=#{billno}")
    HashMap selectIdType(String billno);

    @Select("select ID from DL_B_ADJ_TYPE WHERE ADJ_TYPE_ECODE =#{adjRease}")
    Long selectAdiTypeId(String adjRease);

    //根据单号查询采购退货单的objid
    @Select("SELECT ID FROM DL_B_PUR_RET WHERE BILL_NO =#{billno} AND ISACTIVE='Y' AND STATUS='2' AND SEND_STATUS='1' ")
    Long selectPurRetObjidByBillNo(String billno);




}
